create procedure [dbo].[BAEUpdateOrderEnteredBy] @OrderNum Decimal(18,2),
     @UID varchar(50) as
-- UPDATE the orders table
    UPDATE Orders
    SET ENTERED_BY = @UID
    WHERE ORDER_NUMBER = @OrderNum

    -- UPDATE the trans table
    UPDATE Trans
    SET ENTERED_BY = @UID
    WHERE INVOICE_REFERENCE_NUM = (
        SELECT INVOICE_REFERENCE_NUM FROM Orders WHERE ORDER_NUMBER = @OrderNum)

GO